package com.xxxt.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.xxxt.entity.Grade;
import com.xxxt.entity.Specialty;

public interface SpecialtyMapper {

	List<Specialty> selcetAllSpecialtyByCollegeId(String collegeId);
	
	List<Specialty> selcetAllSpecialty();
	
	List<Specialty> selcetAllPageSpecialtyByCollegeId(String collegeId);
	
	Specialty selcetOneSpecialtyBySpecialtyId(String specialtyId);
	
	boolean insertSpecialty(Specialty specialty);
	
	boolean deleteSpecialty(String specialtyId);
	
	boolean updateSpecialty(@Param("specialtyName") String specialtyName,@Param("collegeId") String collegeId,@Param("id") String id);
	
	List<Grade> selectStudentByTnoAndCollege(List<Specialty> specialties);
	
	Specialty selcetOneSpecialtyByName(@Param("specialtyName")String specialtyName,@Param("collegeId")String collegeId);
}
